﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.CRM
{
    public partial class CustomerInfo
    {
        public const string TABLE_NAME = "Customer";
        public const string INSERT_SQL = "insert into Customer ( [ID], [Name], [Code], [IsDelete], [ContactName], [Address], [ZipCode], [Telephone], [Fax], [Email], [Website], [InputTime], [NextContactTime], [IsFact], [CreatorID], [CreatorName], [Level], [TypeID], [BusLine], [Remark], [Orders]) values ( @ID, @Name, @Code, @IsDelete, @ContactName, @Address, @ZipCode, @Telephone, @Fax, @Email, @Website, @InputTime, @NextContactTime, @IsFact, @CreatorID, @CreatorName, @Level, @TypeID, @BusLine, @Remark, @Orders)";
        public const string UPDATE_SQL = "update Customer set  [ID] = @ID, [Name] = @Name, [Code] = @Code, [IsDelete] = @IsDelete, [ContactName] = @ContactName, [Address] = @Address, [ZipCode] = @ZipCode, [Telephone] = @Telephone, [Fax] = @Fax, [Email] = @Email, [Website] = @Website, [InputTime] = @InputTime, [NextContactTime] = @NextContactTime, [IsFact] = @IsFact, [CreatorID] = @CreatorID, [CreatorName] = @CreatorName, [Level] = @Level, [TypeID] = @TypeID, [BusLine] = @BusLine, [Remark] = @Remark, [Orders] = @Orders where ID = @ID";
        /// <summary>
        /// PK
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 名称
        /// </summary>
        public String Name
        {
            get;
            set;
        }
        /// <summary>
        /// 客户编号
        /// </summary>
        public String Code
        {
            get;
            set;
        }
        /// <summary>
        /// 是否逻辑删除
        /// </summary>
        public Boolean IsDelete
        {
            get;
            set;
        }
        /// <summary>
        /// 默认联系人
        /// </summary>
        public String ContactName
        {
            get;
            set;
        }
        /// <summary>
        /// 地址
        /// </summary>
        public String Address
        {
            get;
            set;
        }
        /// <summary>
        /// 邮编
        /// </summary>
        public String ZipCode
        {
            get;
            set;
        }
        /// <summary>
        /// 电话
        /// </summary>
        public String Telephone
        {
            get;
            set;
        }
        /// <summary>
        /// 传真
        /// </summary>
        public String Fax
        {
            get;
            set;
        }
        /// <summary>
        /// 电子邮件
        /// </summary>
        public String Email
        {
            get;
            set;
        }
        /// <summary>
        /// 网站地址
        /// </summary>
        public String Website
        {
            get;
            set;
        }
        /// <summary>
        /// 登记时间
        /// </summary>
        public DateTime InputTime
        {
            get;
            set;
        }
        /// <summary>
        /// 下次联系时间
        /// </summary>
        public DateTime? NextContactTime
        {
            get;
            set;
        }
        /// <summary>
        /// 是否事实客户
        /// </summary>
        public Boolean IsFact
        {
            get;
            set;
        }
        /// <summary>
        /// 所属人员ID
        /// </summary>
        public Int32 CreatorID
        {
            get;
            set;
        }
        /// <summary>
        /// 所属人员姓名
        /// </summary>
        public String CreatorName
        {
            get;
            set;
        }
        /// <summary>
        /// 级别(优质、一般)
        /// </summary>
        public Int32 Level
        {
            get;
            set;
        }
        /// <summary>
        /// 所属目录分类
        /// </summary>
        public Int32? TypeID
        {
            get;
            set;
        }
        /// <summary>
        /// 乘车线路
        /// </summary>
        public String BusLine
        {
            get;
            set;
        }
        /// <summary>
        /// 备注
        /// </summary>
        public String Remark
        {
            get;
            set;
        }
        /// <summary>
        /// 排序
        /// </summary>
        public Int32 Orders
        {
            get;
            set;
        }
    }

}
